Tabela Declaration

Definicja tabeli Declaration

Name

Declaration

Code

Declaration

Comment

 


Lista kolumn tabeli Declaration

Name

Code

DeclarationID

DeclarationID

ChargeTypeID

ChargeTypeID

POZDeclarationTypeID

POZDeclarationTypeID

SchoolKindID

SchoolKindID

POZSchoolTypeID

POZSchoolTypeID

POZLicenceTypeID

POZLicenceTypeID

DeclarationNo

DeclarationNo

npwz

npwz

Capitation

Capitation

DeclarationInArmy

DeclarationInArmy

FluorineProfile

FluorineProfile

SchoolStatCompanyNo

SchoolStatCompanyNo

DocumentNo

DocumentNo

VersionNo

VersionNo

IdentificationTypeID

IdentificationTypeID

POZDeclarationExtID

POZDeclarationExtID

CurrentDeclarationStatusID

CurrentDeclarationStatusID

AccountingMonth

AccountingMonth

AccountingYear

AccountingYear


Kolumna DeclarationID tabeli Declaration

Definicja kolumny DeclarationID tabeli Declaration

Name

DeclarationID

Code

DeclarationID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ChargeTypeID tabeli Declaration

Definicja kolumny ChargeTypeID tabeli Declaration

Name

ChargeTypeID

Code

ChargeTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna POZDeclarationTypeID tabeli Declaration

Definicja kolumny POZDeclarationTypeID tabeli Declaration

Name

POZDeclarationTypeID

Code

POZDeclarationTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SchoolKindID tabeli Declaration

Definicja kolumny SchoolKindID tabeli Declaration

Name

SchoolKindID

Code

SchoolKindID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna POZSchoolTypeID tabeli Declaration

Definicja kolumny POZSchoolTypeID tabeli Declaration

Name

POZSchoolTypeID

Code

POZSchoolTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna POZLicenceTypeID tabeli Declaration

Definicja kolumny POZLicenceTypeID tabeli Declaration

Name

POZLicenceTypeID

Code

POZLicenceTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DeclarationNo tabeli Declaration

Definicja kolumny DeclarationNo tabeli Declaration

Name

DeclarationNo

Code

DeclarationNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna npwz tabeli Declaration

Definicja kolumny npwz tabeli Declaration

Name

npwz

Code

npwz

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna Capitation tabeli Declaration

Definicja kolumny Capitation tabeli Declaration

Name

Capitation

Code

Capitation

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna DeclarationInArmy tabeli Declaration

Definicja kolumny DeclarationInArmy tabeli Declaration

Name

DeclarationInArmy

Code

DeclarationInArmy

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna FluorineProfile tabeli Declaration

Definicja kolumny FluorineProfile tabeli Declaration

Name

FluorineProfile

Code

FluorineProfile

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna SchoolStatCompanyNo tabeli Declaration

Definicja kolumny SchoolStatCompanyNo tabeli Declaration

Name

SchoolStatCompanyNo

Code

SchoolStatCompanyNo

Data Type

VARCHAR2(14)

Mandatory

No

Comment

 


Kolumna DocumentNo tabeli Declaration

Definicja kolumny DocumentNo tabeli Declaration

Name

DocumentNo

Code

DocumentNo

Data Type

VARCHAR2(40)

Mandatory

No

Comment

 


Kolumna VersionNo tabeli Declaration

Definicja kolumny VersionNo tabeli Declaration

Name

VersionNo

Code

VersionNo

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna IdentificationTypeID tabeli Declaration

Definicja kolumny IdentificationTypeID tabeli Declaration

Name

IdentificationTypeID

Code

IdentificationTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna POZDeclarationExtID tabeli Declaration

Definicja kolumny POZDeclarationExtID tabeli Declaration

Name

POZDeclarationExtID

Code

POZDeclarationExtID

Data Type

VARCHAR2(25)

Mandatory

No

Comment

 


Kolumna CurrentDeclarationStatusID tabeli Declaration

Definicja kolumny CurrentDeclarationStatusID tabeli Declaration

Name

CurrentDeclarationStatusID

Code

CurrentDeclarationStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AccountingMonth tabeli Declaration

Definicja kolumny AccountingMonth tabeli Declaration

Name

AccountingMonth

Code

AccountingMonth

Data Type

NUMBER(5)

Mandatory

No

Comment

Miesiac rozliczeniowy


Kolumna AccountingYear tabeli Declaration

Definicja kolumny AccountingYear tabeli Declaration

Name

AccountingYear

Code

AccountingYear

Data Type

NUMBER(10)

Mandatory

No

Comment

Rok rozliczeniowy


Lista kluczy tabeli Declaration

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Declaration

Definicja klucza Identifier_1 tabeli Declaration

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment